Nightmare with MsSQL and CHINESE language!!!

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Nightmare with MsSQL and CHINESE language!!!

Author

Topic

glas
Starting Member

5 Posts

Posted - 2010-01-06 : 13:47:55

Hello guys, i am in a desperated moment with mssql.
i have to install a software system that works with mssql 2000
the problem is that 90% of it's tables have chinese text...
so when i try to return all rows and translatethem to english or edit them
i get a error

Quote:"Rows cannot be located for updating, some values may have been changing since it was last read"

so data was impossible to be edited.....
i noticed that if i install asian language support nothings happens..but if i change NON-unicode language to chinese (RPC), after restart, when i edit the rows via "corporative administrator" i was ABLE to see all chinese text and edit them.

BUT...changing non-unicode language to the machine killed all other software that was used in that machine....so the machine owner tolds me that if i don't find a way to edit the chinese mssql data without changing non-unicode language to chinese.. (they are using English) i am over......

O_O
does anyone haves any idea?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-06 : 13:52:23

whats the collation setting that you're using? does it support chinese characters?

glas
Starting Member

5 Posts

Posted - 2010-01-06 : 14:09:07

wait i've found it
when i press 2nd click on my table
i see this:

Maintenance:
Maintenance Plan: None
Collation Name: Chinese_PRC_CI_AS

but the "master" table haves collation name: SQL_latin1_general_cp1_ci_as

is this a problem?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-06 : 14:11:11

how are trying to modify data from application? whats the front end language application is written on?

glas
Starting Member

5 Posts

Posted - 2010-01-06 : 14:13:36

i really don't know :S
looks like it's made on visual basic :S
i am not sure...anyway i cannot edit any data from the application beacuse it cannot edit the rows that haves chinese language :S

glas
Starting Member

5 Posts

Posted - 2010-01-06 : 19:09:24

Finally i found an answer
a software Called TOAD from QUEST SOFTWARE that was recommended from a friend it's supposed to be able to read all this mess....

i downloaded trial version and believe it or not
it worked...

Thanks anyway..

P.D now looking for Cracked version of Toad for SQL Server Xpert

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources