| Bug #38779 | ÅÄÖ not woking with Windows xp in notepad source | ||
|---|---|---|---|
| Submitted: | 13 Aug 2008 19:30 | Modified: | 13 Sep 2008 20:03 |
| Reporter: | Christoffer Jansson | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Server: Charsets | Severity: | S3 (Non-critical) |
| Version: | 5.0.51b-community-nt | OS: | Windows (XP pro EN) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | åäö, notepad, SOURCE | ||
[13 Aug 2008 19:34]
Christoffer Jansson
anvandarnamn_id | personnr | doman | anvandarnamn | losenord |
----------------+--------------+----------+--------------+----------+
1 | 198804306614 | anstõlld | christoffer | admin |
Ä
[13 Aug 2008 20:03]
Sveta Smirnova
Thank you for the report. But version 5.0.51a is a bit old. Please upgrade to current version 5.0.67 and try with it. Additionally I think this is not result of MySQL bug. Please check output of SHOW VARIABLES LIKE '%collation%';, SHOW VARIABLES LIKE '%char%', output of command `chcp` of cmd.exe and output of query SHOW WARNINGS issues immediately after INSERT (easiest way is to add this query in your Notepad file).
[13 Sep 2008 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
Description: When using source "/filnamn" in MySQL commando line dose not ÅÄÖ woking in commando line. Cannt då a select * from x where xcolumn = 'åäö'; How to repeat: 1. Open MS Notepad in Windows XP Pro EN and write the following: create table testing (x_id int unsigned not null auto_increment primary key, ANSI_TEST char(3) ); insert into testing value ('0', 'äåö'); Save - encoding type = ANSI 2. Open MySQL commd Promt and point source to 1. 3 Do a select * from testing where ANSI_TEST= 'åäö';