Re: Multiple SID's (instances) possible with Oracle 8 (Unix)?

gschnei@xxxxxxxxx wrote:
> Hi Eric,
>
> thanks for your answer.
>
> Unfortunately, I don't have access to metalink.
>
> Anyways, the scenario is maybe a bit different:
>
> We create the data from a *cough* MySQL-database using the
> MySQLDump-utility.
>
> The output is a tab-separated file, which has korean characters
> UTF-8-encoded.
>
> Again, when loading them into a WE8ISO8859P1 instance, they show up
> fine in our Java-program. However, when loading these data into a
> KO16KSC5601-instance, only garbage shows up.
>
> I'm wondering if KO16KSC5601 is UTF-8 capable?
> Seems not, and this seems to be the problem.
>
> Do you think it's worth a try exporting them from WE8ISO8859P1 and
> importing them into KO16KSC5601 using the exp / imp-utility provided by
> Oracle?
>
> I just tried to load the data now using pure insert-statements,
> however, only garbage shows up again in SQL+, but this might be due to
> a mis-set NLS-LANG-parameter of the client.
>
> Seems I'm running out of ideas here... :(
>
> Thanks anyways!
>
> Greg
>

I think you're right on track with the NLS_LANG settings on the
client...
Make sure your Korean counter part uses the exact same settings
you use *when loading* your file.
He/she can then switch to their normal settings, and see what
gives.

As to oracle instances: you could of course reverse the test, and
set up your own KO16KCS5601 instance (which, I think, is a fixed
two byte UTF characterset, and may not be UTF-8 compatible...
Still am wondering why you can load double-byte characters in
a single byte instance)
--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
.

Relevant Pages

  • Load library failed message
    ... Just started receiving "Load ... Library Failed" message when loading my personal ... settings. ... There is nothing indicating a source of the ...
    (microsoft.public.windowsxp.general)
  • Re: File name extensions for Vic 20 emulators
    ... games even put characters on screen(when run with SYS). ... POKEing before loading from tape. ... Loading from floppy with ",8" will load a program to the current start ...
    (comp.sys.cbm)
  • Re: Start-Up programs & Recent Documents
    ... >1) I want to edit the programs which load on Start-Up, ... to stop them from loading ... It is best to do this through the option in the program's own settings, ...
    (microsoft.public.windowsxp.help_and_support)
  • XP wont load after logo
    ... All was well yesterday and now today I start my computer, get the XP logo and ... then the screen goes blank and never finishes loading. ... I can load in safe ... I haven't installed any new programs or changed any settings. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Problem in printing French Character!
    ... I did change the settings as you described. ... Those characters not shown correctly are those in French characters only, ... To add to this, I tried to print out some other pdf documents in French, ... Whenever I print out the pdf form in French (everything ...
    (microsoft.public.windowsxp.print_fax)