Mark, I found this blurb on Microsoft's site: When dealing with Unicode string constants in SQL Server you must precede all Unicode strings with a capital letter N, as documented in the SQL Server Books Online topic "Using Unicode Data". The "N" prefix stands for National Language in the SQL-92 standard, and must be uppercase. If you do not prefix a Unicode string constant with N, SQL Server will convert it to the non-Unicode code page of the current database before it uses the string.
Also, a lot of the example insert statements I'm finding are using a letter 'N' as a prefix to the value being inserted, as in: insert into user (username) values(N'Oğuz') Does Transfer do anything like that internally when needed? On Wed, Jan 21, 2009 at 3:11 PM, Mark Mandel <[email protected]> wrote: > > Hmnn > > Should just work, Transfer doesn't do anything magical to character > encoding, it should just flow through. > > I can't remember.. do you need to change your collation on the DB side? > > Mark > > On Thu, Jan 22, 2009 at 8:07 AM, Doug Boude <[email protected]> wrote: > > Hi all. forgive me if the answer to this already exists somewhere, but I > > couldn't find it via google or in the documentation. > > > > What is a very nutshell example for properly inserting unicode values > into a > > table using Transfer? Is there any special attribute values in the config > > file I need to set? My table columns are set to nVarchar, nChar, as > > appropriate; my template encoding is set to UTF-8, my db (mssql 2005) is > set > > to SQL_Latin1_General_CP1_CI_AS for collation; but the values are being > > stored as question marks. Any idea on what I need to do? Maybe modify the > > value i'm handing over to the "set" method on my bean? > > > > Thanks in advance. > > > > Doug > > > > > > > > > -- > E: [email protected] > W: www.compoundtheory.com > > > > --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---
