Storing Simplified Chinese in SQL Server 2000

People, am a bit stumped with this one. I need to store a table in SQL Server in the Simplified Chinese language. Can this be done? And how do I get those values in there?

At the moment I have progressed as far as adding the Chinese language into my Control Panel, and can type Chinese literature on my keyboard.

However in a VB6 application, (a text box) when I change my computer language to Chinese, sure, I can enter Chinese text into the box. But as soon as I try to reference this text, it doesn't recognise it.

Please help me with storing Chinese text into variables, and then into SQL server tables.

Thankyou in advance, Peter.
stromberg45Asked:
Who is Participating?
 
Ryan ChongConnect With a Mentor Commented:
I think normal textbox control doesnt support double-byte characters, you need to use a 3rd party chinese software, in order to display your chinese characters in text boxes. Yet, you can done that by using M$ Form 2.0 Object Library.

See:
http://support.microsoft.com/default.aspx?scid=kb;en-us;193540
http:Q_20336162.html
0
 
Ryan ChongCommented:
>> I need to store a table in SQL Server in the Simplified Chinese language. Can this be done?
Try select data type of NChar, NVarchar, NText..
0
 
stromberg45Author Commented:
yes, have used nvarchar.

but how do i get that value in there from interface ???

a text box does not suffice...any ideas ?
0
 
arif_eqbalCommented:
Well you can as well try in the Windows Forms 2.0 Object Library first befre going for third party controls

You can add a reference to Windows Forms 2.0 Object Library these are standrad windows components like TextBoxe, Button etc. use Project -> Components to add the reference

then use those textboxes and see, I am not sure if it will work for Chinese it works for Indian languages though...

0
 
stromberg45Author Commented:
excellent, just need to use the Windows Forms 2.0 for Unicode controls

wooooooooooohhhhhhhhooooooooooooo
0
All Courses

From novice to tech pro — start learning today.