I'm using unicode, but with MySQL. Character Set: utf8 Collation: utf8_bin
<cfprocessingdirective pageEncoding="utf-8" /> on each display page (not 100% sure if that's necessary as I write this out) It just works. Nando 2009/1/22 Mark Mandel <[email protected]> > > 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 > > > > -- Nando M. Breiter The CarbonZero Project CP 234 6934 Bioggio Switzerland +41 76 303 4477 [email protected] --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
