New answers tagged

1

MySQL and MariaDB handle character sets the same. However... Different versions of MySQL have different defaults. Ditto for MariaDB. SET NAMES declares what encoding is in the client. This is independent of the CHARACTER SET on a column or table. (There are, of course, characters that are not representable in latin1, so there can be conversion problems....


0

Your code page is 936 (Chinese). When you start SQL"Plus then this code page is inherited from CMD. Usually you have two possibilities: Set NLS_LANG according to your code page (either as Environment Variable or in Registry). Example set NLS_LANG=.WE8MSWIN1252 for a PC in Central Europe, the language and territory information do not matter for character ...


0

Most likely you corrupted your database and you should consider to make a full restore from backup. ALTER DATABASE CHARACTER SET ... was supported till Oracle version 9 and worked only at certain conditions. Never use clause INTERNAL_USE or make any updates on Oracle system tables unless you are advised by Oracle Support. If you like to change the ...



Top 50 recent answers are included