You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
Submitted by: Sergio Reyes-Peniche (sreyesp)
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.
The text was updated successfully, but these errors were encountered: