Escaping international (unicode) characters in string
- From: "Greg R. Broderick" <usenet200705@xxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 29 May 2007 08:22:53 -0500
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@xxxxxxxxxxxxxxxxxxxxx
A. Top posters.
Q. What is the most annoying thing on Usenet?
---------------------------------------------------------------------
.
- Follow-Ups:
- Re: Escaping international (unicode) characters in string
- From: Erland Sommarskog
- Re: Escaping international (unicode) characters in string
- Prev by Date: Re: needed: 1 + null = 1
- Next by Date: Re: Escaping international (unicode) characters in string
- Previous by thread: What do you think about the checksum function ?
- Next by thread: Re: Escaping international (unicode) characters in string
- Index(es):
Relevant Pages
|
