How to query fields that contain accents?

Problems, tips, hints - all about usage.

How to query fields that contain accents?

Postby Winfried » Mon Jun 19, 2017 11:48 am

Hello

After importing a CSV file encoded in UTF8, I notice that accents aren't displayed, and queries fail when they deal with words with accents:

Image

OTOH, the query does work OK when using
Code: Select all
WHERE … LIKE "%le-de-France";


Is this a bug in Windows 7, SQLite, or SQLite Studio (3.1.1)?

Thank you.
Winfried
 
Posts: 1
Joined: Mon Jun 19, 2017 11:39 am

Re: How to query fields that contain accents?

Postby Googie » Tue Jun 27, 2017 8:31 am

Did you select proper encoding while configuring import dialog? There is encoding dropdown.
Googie
Site Admin
 
Posts: 780
Joined: Wed Jul 27, 2011 8:04 pm


Return to Usage

Who is online

Users browsing this forum: No registered users and 1 guest

cron