cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
TWE
TWE
Level III

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Craige_Hales
Super User

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.

Craige

View solution in original post

2 REPLIES 2
Craige_Hales
Super User

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.

Craige
TWE
TWE
Level III

Re: Diameter symbol SQL Insert

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