|
Posted by vincent wehren on 06/29/05 22:54
| "dBlue" <zkvneml@hotmail.com> schrieb im Newsbeitrag
news:1119999569.407793.143810@g49g2000cwa.googlegroups.com...
|Hi all,
|
|I have an issue on querying against UTF-16 encoded characters in
|SQL2000 database: For example the "Lσpez" is saved into database as
|"LΓ³pez" (due to the UTF-16 encoding);
This is not a UTF-16 representation but UTF-8.
--
Vincent Wehren
|somehow, when I query data
|with conditions of "like 'lop%'" or "like 'Lσp%'", the row of Lσpez
|would not return.
|NOTE: the accent insensitive collation can not help in this case.
|Thank you,
|Albion(052X)
[Back to original message]
|