troubleshooting Question

SQL database - querying with foreign characters and saving blob data

Avatar of WestCoast_BC
WestCoast_BCFlag for Canada asked on
DatabasesSQL
6 Comments1 Solution101 ViewsLast Modified:
I have a C++ application that connects to a Firebird SQL database. The database is using UTF8 as its character set.

The database contains tables that have strings that are of type varchar and contains blob data that is of type 'blob sub_type 1'

Originally the connection to the database did not specify the character set but this was causing a Malormed String SQL error when I tried to do a query that contained a foreign character like É. I added CHARSET=UTF8 to the connection string which solved my initial problem when querying with a foreign character but now I get an SQL error when I try to save blob data.

Does anyone have any suggestions of what I should do. Any help is appreciated.
ASKER CERTIFIED SOLUTION
WestCoast_BC

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros