> CFDJ'ers:
Wrong list.
> When trying to add characters like � and �, my SQL 7
> server tells me I have not enclosed my strings properly.
> I'm assuming the tilde is breaking it. Any way around
> that, other than looking for that character and replacing
> it, with say the HTML equivalent that works? Or will I
> just have to do a replace() on the string?
I haven't run into this problem, personally, so this is just a shot in the
dark. Have you preceded your literal strings with the Unicode marker?
INSERT INTO mytable
(myfield1, myfield2)
VALUES
(N'This is a Unicode string', N'This is another Unicode
string')
Also, are the fields themselves Unicode datatypes (nchar, nvarchar, ntext)?
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
