RE: Yahoo! Groups: Welcome to TOADSQL. Visit today!

Toad for Oracle
1

RE: Yahoo! Groups: Welcome to TOADSQL. Visit today!

2

(Resent due to going missing!)

Afternoon Stéphane,

Thank you for your message

I have downloaded a trial version 10 of Toad

And the result is he same, nothing in the field "NAME"

Are you sure that it is not a problem of parameters in our machine ?

And yes ! the result of that search could be "bracelet"

Ok, I'm puzzled now. Toad 10 is able to cope with Unicode and should be able to see your data. I've CC'd the other Toad list as this is more a Toad problem than an SQL problem. Maybe one of the developers will chime in and point you in the right direction.

Sorry I can't help any more! :frowning:

Background for the Toad devs:

  • Original thread is on ToadSQL.
  • User has Toad 7.4 and is connecting to a database.
  • Data in a table has a data type on NVARCHAR2 which is character set.
  • Data shows up in the grid as blank. Options on Toad to trim CHAR/VARCHAR fields is off.
  • Data exists in the table:

SELECT DUMP(name, 16)
FROM tterm
WHERE base ='20839'

DUMP(NAME,16)
Typ=1 Len=16: 0,62,0,72,0,61,0,63,0,65,0,6c,0,65,0,74

  • The above corresponds to 'bracelet'.
  • User has now got a trial version of Toad 10 and still sees a blank in the grid.
  • Norm is beat!

Any clues gratefully appreciated, if not by me alone, certainly by Stéphane.

Cheers,
Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

3

Wow, about 4 messages in a couple of days!
This almost feels like a 'flow'. :slight_smile:

regards,
Peter

Op 19-03-2010 8:47, Dunbar, Norman schreef:

(Resent due to going missing!)

Afternoon Stéphane,

Thank you for your message

I have downloaded a trial version 10 of Toad

And the result is he same, nothing in the field "NAME"

Are you sure that it is not a problem of parameters in our machine ?

And yes ! the result of that search could be "bracelet"

Ok, I'm puzzled now. Toad 10 is able to cope with Unicode and should be
able to see your data. I've CC'd the other Toad list as this is more a
Toad problem than an SQL problem. Maybe one of the developers will chime
in and point you in the right direction.

Sorry I can't help any more! :frowning:

Background for the Toad devs:

  • Original thread is on ToadSQL.
  • User has Toad 7.4 and is connecting to a database.
  • Data in a table has a data type on NVARCHAR2 which is character set.
  • Data shows up in the grid as blank. Options on Toad to trim
    CHAR/VARCHAR fields is off.
  • Data exists in the table:

SELECT DUMP(name, 16)
FROM tterm
WHERE base ='20839'

DUMP(NAME,16)
Typ=1 Len=16: 0,62,0,72,0,61,0,63,0,65,0,6c,0,65,0,74

  • The above corresponds to 'bracelet'.
  • User has now got a trial version of Toad 10 and still sees a blank
    in the grid.
  • Norm is beat!

Any clues gratefully appreciated, if not by me alone, certainly by Stéphane.

Cheers,
Norm. [TeamT]

Information in this message may be confidential and may be legally
privileged. If you have received this message by mistake, please notify
the sender immediately, delete it and do not copy it to anyone else. We
have checked this email and its attachments for viruses. But you should
still check any attachment before opening it. We may have to make this
message and any reply to it public if asked to under the Freedom of
Information Act, Data Protection Act or for litigation. Email messages
and attachments sent to or from any Environment Agency address may also
be accessed by someone other than the sender or recipient, for business
purposes. If we have sent you information and you wish to use it please
read our terms and conditions which you can get by calling us on 08708
506 506. Find out more about the Environment Agency at
www.environment-agency.gov.uk

Information in this message may be confidential and may be legally
privileged. If you have received this message by mistake, please notify
the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you
should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to
under the Freedom of Information Act, Data Protection Act or for
litigation. Email messages and attachments sent to or from any
Environment Agency address may also be accessed by someone other than
the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our
terms and conditions which you can get by calling us on 08708 506 506.
Find out more about the Environment Agency at www.environment-agency.gov.uk

4

Good Evening Norm (from the considerably balmier side of the pond…)

are you running a triple byte or quadruple byte character sets??
is your Database encoded for UTF-8 or UTF-16?

Martin

Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité

Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung
oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem
Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung.
Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung
fuer den Inhalt uebernehmen.

Ce message est confidentiel et peut être privilégié. Si vous n’êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l’expéditeur. N’importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l’information seulement et n’aura pas n’importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.

5

Morning Martin,

are you running a triple byte or quadruple byte character sets??
is your Database encoded for UTF-8 or UTF-16?

It's not my database! It belongs to Stéphane. The NLS_NCHAR_CHARACTERSET is AL16UTF16.

Cheers,
Norm.

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk