Bug 92286

Summary: problem with french character
Product: [Retired] Red Hat Linux Reporter: Eric Doutreleau <edoutreleau>
Component: mysqlAssignee: Patrick Macdonald <patrickm>
Status: CLOSED NOTABUG QA Contact: David Lawrence <dkl>
Severity: medium Docs Contact:
Priority: medium    
Version: 9   
Target Milestone: ---   
Target Release: ---   
Hardware: i686   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2003-06-05 11:47:42 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Eric Doutreleau 2003-06-04 15:42:46 UTC
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (X11; U; Linux i686; fr-FR; rv:1.2.1) Gecko/20030225

Description of problem:
i'm trying to import some data in mysql which contains some french characters.
and i can't display correctly them in the database.

Version-Release number of selected component (if applicable):
mysql-3.23.56

How reproducible:
Always

Steps to Reproduce:
1. i m trying to insert the following line 
1535;kde-i18n-Slovenian;2.1.1;Support du slov�ne pour KDE.

2. and the result in the mysql console is
3. 
1535 | kde-i18n-Slovenian | 2.1.1   | Support du slov?ne pour KDE.

    

Actual Results:  kde-i18n-Slovenian | 2.1.1   | Support du slov?ne pour KDE.

Expected Results:  kde-i18n-Slovenian | 2.1.1   | Support du slov�ne pour KDE.

Additional info:

the CHARSET i use is UTF8
my locale is fr_FR.UTF-8

i m wondering if mysql support UTF-8 locale

Comment 1 Eric Doutreleau 2003-06-05 11:47:42 UTC
Well it wasn't a bug

indeed the input file was wrong
i convert it to utf-8 and my problem was solved