Subject | Re: problem with retrieving data |
---|---|
Author | rockyoh73505 |
Post date | 2011-01-06T01:15:31Z |
ahhhhh I am sorry that I have not written more clearly.....
And I assure you this is not problem with delphi (even though
I have posted the delphi program on it so I sorry for creating
confussion.... >.<;; )
I am trying to use the foreign char using either UTF8 or
KSC_5601 but I have several difficulties...
If I create the database using the UTF8 it will insert the
value inside the data base unbroken (for instance I am entering
"hello"<- this would be written in korean;
it will come out like "?fr?" <-obiously this is just example...
So I have created folder using the KSC_5601 this retrieve the
data unbroken (i.e. it comes out as it was put in...) but when I
try to insert the data I get following error code.
-> "SQL ERROR: MALFORMED STRING. ERROR CODE: -104. INVALID TOKEN
THE SQL: INSERT INTO TEST (M_DATE, TEST, NOTE) VALUES ('TODAY',
'ȣȣȣ', 'ȣȣȣȣ');"
so I am not sure how to solve this problem...
I greatly appreciate your response Ismael and I thank you all
for taking interest...
And I assure you this is not problem with delphi (even though
I have posted the delphi program on it so I sorry for creating
confussion.... >.<;; )
I am trying to use the foreign char using either UTF8 or
KSC_5601 but I have several difficulties...
If I create the database using the UTF8 it will insert the
value inside the data base unbroken (for instance I am entering
"hello"<- this would be written in korean;
it will come out like "?fr?" <-obiously this is just example...
So I have created folder using the KSC_5601 this retrieve the
data unbroken (i.e. it comes out as it was put in...) but when I
try to insert the data I get following error code.
-> "SQL ERROR: MALFORMED STRING. ERROR CODE: -104. INVALID TOKEN
THE SQL: INSERT INTO TEST (M_DATE, TEST, NOTE) VALUES ('TODAY',
'ȣȣȣ', 'ȣȣȣȣ');"
so I am not sure how to solve this problem...
I greatly appreciate your response Ismael and I thank you all
for taking interest...