Insert euro symbol in database from ignition

Hi guys,

I have tried to insert the euro(€) symbol in the database using the insert query from the vision button action performed but the format is not ok in the database.

val = str(202) + str("€")

Display the database in this format:


Database = SQL Server
Ignition = 8.1.17

when I directly insert it from the SQL server then worked perfectly. but When I tried to insert it from the ignition then not ok.

Any idea how to fix this?


don't use str(). That is not unicode-friendly. Use the u'' marker for jython string constants that need unicode treatment. So:

val = str(202) + u'€'

@pturmel Thank you so much for your quick response.

Worked perfectly!!