Re: Oracle 10G - character sets.

On Jan 8, 1:43 pm, "markpapadakis" <markpapada..._at_gmail.com> wrote:
> > NLS_LANG was .US7ASCII in your client session during import.
> > Hence your problem.
>
> > --
> > Sybrand Bakker
> > Senior Oracle DBAThank you Sybrand,
>
> However, after dropping the user(schema) and trying again, this time
> having set NLS_LANG prior to invoking imp
>
> import done in EL8ISO8859P7 character set and AL16UTF16 NCHAR character
> set
> import server uses WE8MSWIN1252 character set (possible charset
> conversion)
>
> still doesn't work. I am getting '?' instead of greek characters. It
> works just fine on sqlplus though.
>
> Mark

Still doesn't work points to characterset conversion and/or incorrect NLS_LANG settings somewhere.

For your reference

http://www.oracle.com/technology/tech/php/pdf/globalizing_oracle_php_applications.pdf

and
http://www.oracle.com/technology/tech/globalization/htdocs/nls_lang%20faq.htm

which I got after searching for 'PHP NLS_LANG' on the Oracle site.

-- 
Sybrand Bakker
Senior Oracle DBA