topic Re: Diameter symbol SQL Insert in Discussions

Diameter symbol SQL Insert

TWE — Sat, 10 Jun 2023 23:41:42 GMT

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

Re: Diameter symbol SQL Insert

Craige_Hales — Sun, 12 Dec 2021 23:40:47 GMT

(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.

Re: Diameter symbol SQL Insert

TWE — Mon, 13 Dec 2021 14:16:19 GMT

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