To insert data into the database I want to use the 'load SQL query...' from the file menu.
When the file to open is Unicode UTF-8 encoded and in the file are characters e.g. 'µ' then this character will be displaed in CompactView and inserted into the database as 'µ'.
If I use another editor to open the file and copy the insert statements by copy&paste into the SQL editor panel then the characters will be displayed well.
In the mean time the amount of data is too big for my clipboard, so I want to use the regular 'load SQL query...'.
I think this could be a good point for the next version ;)
Thank you very much
Roland
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
View and moderate all "General Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Discussion"
To insert data into the database I want to use the 'load SQL query...' from the file menu.
When the file to open is Unicode UTF-8 encoded and in the file are characters e.g. 'µ' then this character will be displaed in CompactView and inserted into the database as 'µ'.
If I use another editor to open the file and copy the insert statements by copy&paste into the SQL editor panel then the characters will be displayed well.
In the mean time the amount of data is too big for my clipboard, so I want to use the regular 'load SQL query...'.
I think this could be a good point for the next version ;)
Thank you very much
Roland
Hi Roland,
Please test the new version 1.4.5 released to correct the error.
Thanks
View and moderate all "General Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Discussion"
Great!
It now works perfectly.
I'm surprised that you could fix it in that short time.
Thank you again.
Roland