Hi,
How to handle Special character in cockroachdb
I am getting below error when running a select sql on a table. One of the column is showing this error. We have imported the data from csv file and the csv file is showing data properly. How to handle this while importing -
| org.jkiss.dbeaver.model.exec.DBCException: SQL Error [22000]: Invalid character data was found. This is most likely caused by stored data containing characters that are invalid for the character set the database was created in. The most common example of this is storing 8bit data in a SQL_ASCII database. | |
|---|---|
| at org.jkiss.dbeaver.model.impl.jdbc.data.handlers.JDBCAbstractValueHandler.fetchValueObject(JDBCAbstractValueHandler.java:55) |