|
|
Posted by Greg R. Broderick on 05/29/07 13:22
Y'all:
I am needing some way, in the SQL Server dialect of SQL, to escape unicode
code points that are embedded within an nvarchar string in a SQL script,
e.g. in Java I can do:
String str = "This is a\u1245 test.";
in Oracle's SQL dialect, it appears that I can accomplish the same thing:
INSERT INTO TEST_TABLE (TEST_COLUMN) VALUES ('This is a\1245 test.");
I've googled and researched through the MSDN, and haven't discovered a
similar construct in SQL Server. I am already aware of the UNISTR()
function, and the NCHAR() function, but those aren't going to work well if
there are more than a few international characters embedded within a
string.
Does anyone have a better suggestion?
Thanks muchly!
GRB
--
---------------------------------------------------------------------
Greg R. Broderick usenet200705@blackholio.dyndns.org
A. Top posters.
Q. What is the most annoying thing on Usenet?
---------------------------------------------------------------------
Navigation:
[Reply to this message]
|