Problems and Solutions>Databases

Foreign characters in data source field names

 

Article #:

0009

Contributor:

Joanne Irvine-Smith

GF version:

3.05

Applies to:

DataLinks

Last updated:

July 2, 2001

Problem

When filling a document that contains a DataLink, processing stops and an error message is displayed referring to the fields in the data source.

Description

ODBC does not allow foreign characters in field names. If your data source field names contain foreign characters, the ODBC driver cannot interpret the characters and an error message is generated.

Solution

As far as possible, avoid using foreign characters when naming data source fields. GhostFill accepts only the following characters in field names:

 

CHARACTER DESCRIPTION

EXAMPLE

Uppercase text

TEST

Lowercase text

test

Underscore

_

Numbers

0-9