Board index » delphi » memo fields and special charcters

Andreas Wehner

Delphi Developer
Tue, 13 Jan 2004 16:12:42 GMT

memo fields and special charcters

I'am uaing dbmemo to store text in a paradox memo field. If I'am using
character like or the euro sign the database stores #. What can I do
to keep the original character

thanks for your help

Andreas Wehner

 
Glenn Hancoc

Delphi Developer
Tue, 13 Jan 2004 21:08:52 GMT

Re:memo fields and special charcters


use the richtextmemo instead of the plain memo component.  I think that
should take care of it...

--
Glenn Hancock
SofTek Software Int'l Inc.
www.softeksoftware.com
ghanc...@softeksoftware.com
770-490-7899

Brian Bushay Team

Delphi Developer
Wed, 14 Jan 2004 11:23:23 GMT

Re:memo fields and special charcters


Quote
>I'am uaing dbmemo to store text in a paradox memo field. If I'am using
>character like or the euro sign the database stores #. What can I do
>to keep the original character

The language driver the table uses needs to support the characters you enter
into the tables fields.   The default language driver is set in the BDE config
and the default language driver when the table is created is the one that is
used.

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Andreas Wehne

Delphi Developer
Fri, 16 Jan 2004 00:58:46 GMT

Re:memo fields and special charcters


i think that is exactly the problem. the tables where this error occur using
a "pdox intl" driver. i think i have to change the language driver to "pdox
ansi intl". The question is: How can i do this ?

thanks for your help

Andreas Wehner

"Brian Bushay TeamB" <BBus...@Nmpls.com> schrieb im Newsbeitrag
news:dov3mt8hcpbk951vr4mgemnh0e2s93m1r8@4ax.com...

Quote
> >I'am uaing dbmemo to store text in a paradox memo field. If I'am using
> >character like or the euro sign the database stores #. What can I do
> >to keep the original character

> The language driver the table uses needs to support the characters you
enter
> into the tables fields.   The default language driver is set in the BDE
config
> and the default language driver when the table is created is the one that
is
> used.

> --
> Brian Bushay (TeamB)
> Bbus...@NMPLS.com

Brian Bushay Team

Delphi Developer
Fri, 16 Jan 2004 11:03:29 GMT

Re:memo fields and special charcters


Quote
>i think that is exactly the problem. the tables where this error occur using
>a "pdox intl" driver. i think i have to change the language driver to "pdox
>ansi intl". The question is: How can i do this ?

Restructure the tables with the database desktop and there is an option to
change the language driver.

Or change the default language driver create new tables then batchmove or use an
insert query to add the old records

Or use dbiDoRestructure
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Andreas Wehne

Delphi Developer
Fri, 16 Jan 2004 15:52:00 GMT

Re:memo fields and special charcters


thanks for your help. i think i will try to use dbiDoRestructure.

Andreas Wehner

Quote
Brian Bushay TeamB wrote:
> >i think that is exactly the problem. the tables where this error occur using
> >a "pdox intl" driver. i think i have to change the language driver to "pdox
> >ansi intl". The question is: How can i do this ?

> Restructure the tables with the database desktop and there is an option to
> change the language driver.

> Or change the default language driver create new tables then batchmove or use an
> insert query to add the old records

> Or use dbiDoRestructure
> --
> Brian Bushay (TeamB)
> Bbus...@NMPLS.com

Tomislav Kard

Delphi Developer
Sat, 17 Jan 2004 05:09:11 GMT

Re:memo fields and special charcters


Hi Andreas!

On Fri, 27 Jul 2001 10:12:42 +0200, Andreas Wehner

Quote
<Weh...@ass-gmbh.com> wrote:
>I'am uaing dbmemo to store text in a paradox memo field. If I'am using
>character like or the euro sign the database stores #. What can I do
>to keep the original character

try to set fields property Transliterate to false, that should prevent
conversion of chars.

tomi.

Olivier Beltram

Delphi Developer
Sat, 17 Jan 2004 12:42:08 GMT

Re:memo fields and special charcters


Quote
> I'am uaing dbmemo to store text in a paradox memo field. If I'am using
> character like or the euro sign the database stores #. What can I do
> to keep the original character

When using any string type field (TMemoField, TStringField), make sure that
the property TRANSLITERATE is set to FALSE (it's true by default). Otherwise
Paradox will try to be smart and convert the characters of you non-US
keyboard to those of a US keyboard.

Olivier

Andreas Wehne

Delphi Developer
Tue, 20 Jan 2004 14:48:41 GMT

Re:memo fields and special charcters


thanks that helped

Andreas

Quote
Olivier Beltrami wrote:
> > I'am uaing dbmemo to store text in a paradox memo field. If I'am using
> > character like or the euro sign the database stores #. What can I do
> > to keep the original character

> When using any string type field (TMemoField, TStringField), make sure that
> the property TRANSLITERATE is set to FALSE (it's true by default). Otherwise
> Paradox will try to be smart and convert the characters of you non-US
> keyboard to those of a US keyboard.

> Olivier

Other Threads

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

2. Help! Special characters in Memo component.(D1)

3. What is the syntax for copy a memo to a database memo field

4. Memo Fields in Access and Memo object in Delphi

5. Loss of data converting memo field to formatted memo

6. BDE is translating charcters...

7. How to save data in memo box to memo field of Dbase3+

8. How to prevent the special meanings of special symbols

9. Copy data from string field to memo field

10. Tables with special characters in field names