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 );