Board index » delphi » Special caracters in memo field with SQL-Server 6.5 installed with binary order

Moacir Alves Schmidt

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Special caracters in memo field with SQL-Server 6.5 installed with binary order

Hi, friends!

Could anyone help me with this question:

I'm using Delphi 3.0, with BDE 5.01 and Microsoft SQL-Server 6.5, service
pack4. When I try to insert a special character (like those which exist in
portuguese language: ?, , , , etc...) into a *MEMO* field, through my
application, this caracter is changed to another one. I've been unable to
write these characters into memo fields.

I've already checked all LANDDRIVES from BDE Configuration, but I think it
isn't the problem because simple fields (char and varchar) work well.

Help me, please!

Thanks in advance,

<Moacir Alves Schmidt>
<Brazil>

 
Moacir Alves Schmid

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Special caracters in memo field with SQL-Server 6.5 installed with binary order


Hi, friends!

Could anyone help me with this question:

I'm using Delphi 3.0, with BDE 5.01 and Microsoft SQL-Server 6.5, service
pack4. When I try to insert a special character (like those which exist in
portuguese language: ?, , , , etc...) into a *MEMO* field, through my
application, this caracter is changed to another one. I've been unable to
write these characters into memo fields.

I've already checked all LANDDRIVES from BDE Configuration, but I think it
isn't the problem because simple fields (char and varchar) work well.

I forgot to tell in the last message that the Microsoft-SQL Server is
installed with binary sort order and character set: code page 850
(Multilingual).

Help me, please!

Thanks in advance,

<Moacir Alves Schmidt>
<Brazil>

Other Threads

1. SQL Server 6.5 and Memo fields

2. Installing MS SQL SERVER 6.5 Client with Install Shield

3. Memo fields in Delphi and Text fields in MS SQL 6.5

4. Installing sql-links for MS sql server 6.5

5. How do I change the row being returned from a SQL SERVER 6.5 binary(1)

6. DOES BDE SUPPORT SQL 6.5 MEMO FIELDS??

7. Memo Fields in MS SQL 6.5

8. SQL 6.5/ODBC/D2/BDE/Memo field issue

9. SQL Server 6.5 x SQL Server 7

10. Problem with Identity field in Delphi 2, with ODBC SQL server 6.5 link