Issue Details (XML | Word | Printable)

Key: CORE-5575
Type: Bug Bug
Status: Open Open
Priority: Minor Minor
Assignee: Unassigned
Reporter: Sergio Reyes-Peniche
Votes: 0
Watchers: 2

If you were logged in you would be able to see more operations.
Firebird Core

isql crash on accented character insert

Created: 02/Jul/17 11:08 PM   Updated: 02/Jul/17 11:08 PM
Component/s: ISQL
Affects Version/s: 3.0.2
Fix Version/s: None

Environment: Windows Vista sp2

QA Status: No test

 Description  « Hide
My Windows cmd.exe defaults to DOS850. I can insert accented characters into an utf8 database from isql like this:

insert into test01 (m_text) values (_dos850 'Séptimo registro.');

select * from test01 shows gibberish instead of the 'é'. If I exit from isql, change codepage to UTF8 with
`chcp 65001` and run isql again, the 'é' shows OK (I have my cmd.exe configured to use Lucida Console, a unicode font).

But, with cmd.exe using UTF8, if I try now:

insert into test01 (m_text) values ('Enésimo registro.');

isql crashes and returns me to the cmd prompt.

I have tried with (_utf8 'Enésimo registro.') and (_dos850 'Enésimo registro.') and isql keeps crashing. I must exit isql,
chcp 850, run isql and insert the new data, exit isql, chcp 65001 and rerun isql to check the new inserts.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.