Hi We are running Coldfusion MX 6.1 with oracle databse chracterset as AL32UTF8 and NLS_Length_Sementac is CHAR
before we use Oracle Default Characterset with NLS_Length_Sementac is Byte In the New DB character set , in the Select statment it generate empty space , so when i use those values in any insert statment i am getting insrerted value too large error Following is an Example In Database in Tablea i have a column ColumnA Tabela ColumnA char(1) ID number select * from tabela ColumnA ID -------- ---- N(No space in dB) 1 N(No space in dB) 2 Y(No space in dB) 3 In coldfusion Template I put the select statment as <cfquery name=test datasource = test1> Select columnA from tablea where id = 1 <cfquery> when i dump the values of columnA it has the data with space also i set the value to text box there also it has spaces and use the columna in values and insert in to the other table tableB TableB ColumnB Char(1) Insert into tabelB (columnb) values (test1.ColumnA) above insert statement gives error insert value too large Anyone can help me why coldfusion is behavioring like this with oracle databse as Al32utf8 character set ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283236 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
