Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: what characterset to use?
sybrandb_at_hccnet.nl wrote:
>>2) If you (as misguided admins too often do) mistakenly set NLS_LANG >> to the database character set, no character conversion AND NO >> INTEGRITY CHECKS are performed and you can store all sort of garbage >> in your database without even noticing. It will cause problems later on, >> though. This is an Oracle bug in my opinion, although Oracle will >> probably disagree with me on this.
You got me wrong.
Of course it is not Oracle's bug if I set my NLS_LANG wrong.
But it is Oracle's bug (in my opinion) if I have set the client character set to US7ASCII, insert a byte > 127 in a text field, and neither get an error nor (as Oracle seems to prefer) have the byte clandestinely converted to a question mark.
I claim that the missing check for incorrect characters is a bug.
Yours,
Laurenz Albe
PS: By "bug" I mean a software error, not a user mistake. Received on Fri Aug 24 2007 - 05:21:59 CDT
![]() |
![]() |