444391_en-US

liliconcom

Diameter symbol SQL Insert

Hi,

I have the diameter symbol ⌀ as a char in a column in a DB table (it was created with Excel but it is complicated to prevent typing in the symbol because many people are working with that and there are historical data which I dont want to change...). The JMP Query (via JSL) imports the symbol correctly. But when I want to insert the symbol back into a DB table, it exports an ? instead of the ⌀. Is there any way to insert the symbol correctly?

Thanks,

dbc = Create Database Connection( "CONNECTION" );
sql = Eval Insert("
INSERT INTO DB.DATATABLE
(COLUMN) 
VALUES ('⌀')
");
Execute SQL( dbc, sql );

 

Data AccessMass CustomizationWindowsRe: Diameter symbol SQL Insert

That's it. Sometimes it is very simple. Many Thanks!

Re: Diameter symbol SQL Insert

(untested...I'm not a frequent user of SQL...)

https://stackoverflow.com/questions/10965589/unicode-data-type-in-sql  suggests using

VALUES(N'⌀')

but it is probably vendor specific and depends on the field in the database being Nchar or Nvarchar rather than char or varchar.