Everything goes through a <cfqueryparam>, so if CF can do it natively, which I believe it can, it should just work in Transfer, there should be no other heavy lifting required.
Anyone else doing i18n stuff with Transfer? Mark On Thu, Jan 22, 2009 at 10:27 AM, Doug Boude <[email protected]> wrote: > 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 >> >> > -- 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 -~----------~----~----~----~------~----~------~--~---
