Data Storing Problem......

Hi everyone,

I have some data which is in korean Language and i want to store that data in sql server 2000 table's row.But i am not able to store it.

When i try to store it then it display me square box in table.

Does anybody have any idea about this matter?

Plz reply me back as soon as possible.

Thanks

---Nimesh Patel

Please check out Books On Line for SQL Collations. Setting the collation level allows you to store data in different languagues.|||

Collations have nothing to do with what you can or can't store. Collations are the rules that define the order of alphabets, which is important for sorting.

Are the columns that you are storing the data into defined as nvarchar, nchar, or ntext?

After pulling out the data from the database, are you displaying it in a font that actually has those characters?

||| I think I need to check out the BOL first. thanks for the correction Motley and good to see you back. Its been kinda dull here lately..|||Good to see you are still around as well ;-)|||Yes.. been fighting the battle all alone|||You've never been alone, you've just been doing such a great job that I rarely have to say anything anymore

Data mining prediction

Hi again....

I have tree models trained and now how do I perform predictions? I've read that i can use ADO in my vb language so could anyone give me some code lines about prediction using ADO and Vb language? and how to view the prediction in my vb application?

Thank's a lot

Once you have a trained model, you can do perform predictions by querying the model using the DMX language (which is similar to SQL). Take a look at the source code for the DM Sample which uses ADO/VB to send your queries to AS 2000 and displays the result in a hierarchical grid control: http://www.sqlserverdatamining.com/DMCommunity/Downloads/Links_LinkRedirector.aspx?id=85

Data migration

Dear all
I want to know if sql server 2000 supports 2-bytes language, say Chinese? I
have an Excel file with Chinese characters in it, after imported into sql
server table using dts, all Chinese become question mark(?).
How should I do?
--
Best regards,
RichardSee my reply in .dts
--
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"lurc" <lurchot@.hotmail.com> wrote in message
news:uSsMTkazDHA.540@.tk2msftngp13.phx.gbl...
> Dear all
> I want to know if sql server 2000 supports 2-bytes language, say Chinese?
I
> have an Excel file with Chinese characters in it, after imported into sql
> server table using dts, all Chinese become question mark(?).
> How should I do?
> --
> Best regards,
> Richard
>

Data format conversion.

Hello,

I am jivesh, working on live project with asp.net & sql server2003. I am facing one problem, client is in belgium uses Dutch language, and we are english. when we enter decimal value in sql database it gets save but the client has server in dutch language and in Dutch "." is ",", so here sql gets conflict , it takes "," as character & gives error, eg .

Add an item and fill out the fields with numbers (e.g. 45.05 ). When you want to edit this item later on, the number has been changed to e.g. 45,05 and this gives an error .

While we input the values 45.05 it gets save as it is, but when we retrive the value in textbox to edit, it comes in the way 45,05. the dot gets converted in comma. please help me soon.

Thanx

As long as you use a numeric type, the comma or dot isn′t stored at all, this is just a case of client presentation issue. So that should be an issue. It depends on your client code how you handle those inserts to the database. Normally you pass a common decimal type to the server, so this one gets "converted" (or just inserted) into the database.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de