scrambled character,sql2000 with table name and colum using japanese
character
lazarus / 16-Databases

----------------------------------------------------------------------
kukumaiwu · 2010-10-07 03:44

excuse me for my question.
i am new to lazarus and pascal.
just follow the page below,
i have successed several times in getting the data from sql server
2000 sp4(these table names donot contain japanese characters).
http://forum.lazarus.freepascal.org/index.php/topic,3329.0.html
but also failed several times 'cause the table name is using japanese
characters
those data i get is unreadable also due to the japan characters in it
of cause the columns are the same
how should i do?

regards,
kukumaiwu

----------------------------------------------------------------------
kukumaiwu · 2010-10-07 03:59

there are two snapshot of this question
1.the table NOUSINGJPCHARS
http://www.flickr.com/photos/48299441@N00/5058656273/
2.the table USINGJPCHARS
http://www.flickr.com/photos/48299441@N00/5058656275/

regards,
kukumaiwu

----------------------------------------------------------------------
Lacak2 · 2010-10-08 04:08

So problem is only in column names, not in data ?
What SQL do you Open ?
If you change SQL to not return any data and Open, same error happens
?
(select * from table where 1=2)
What version of FPC do you use ?)