Problem inserting arabic caracters in SQL server table

[kingofcar]

I have a problem when trying to insert arabic characters in SQL Server data
base from a Coldfusion MX 7 cfml page. All arabic sent characters to database
become question marks "????????????".

Is there any problem in supporting arabic characters in Coldfusion MX 7 ? or
is there any settings to change from the ColdFusion administrator?
I need your help.
Thank you any advanceText

[PaulH *TMM*]

kingofcar wrote:

> Is there any problem in supporting arabic characters in Coldfusion MX 7 ? or
> is there any settings to change from the ColdFusion administrator?

no, no problem. what db driver? JDBC or odbc? should be JDBC. what datatype?
should be ntext/nvarchar/nchar. to make it easy on yourself use unicode rather
than a codepage. see this for a simple example:

[url]http://www.sustainablegis.com/unicode/greekTest.cfm[/url]

[Unregistered]

write the character 'N' before the arabic data
ex:-
insert into tablename values(' Nالبيانات ',' N البيانات ');