Skip to main content
X
xstortionist
Inspiring
August 27, 2008
Question

Database questions / Help.

  • August 27, 2008
  • 3 replies
  • 476 views
Hi,
I'm back once again with another newbie question for you elite coldfusion developers. Basically I'm in the works of creating a application that allows me to upload site news to a database and then output on our web site. Sounds easy enough right? Well I'm very new to CF and I'm still a beginner. here's my problem:

http://mswebsol.com/testdb/news.cfm

if you notice there is a weird box character being displayed and also alot of the text isn't being outputted. Why is this? I've been trying to find a solution for about an hour and still no luck.

Help would be greatly appreciated. All I did was created a form which you can view here:

http://mswebsol.com/testdb/news.cfm

here's the code:





This topic has been closed for replies.

3 replies

N
Newsgroup_User
Inspiring
August 28, 2008
xstortionist wrote:
> if you notice there is a weird box character being displayed and also alot of
> the text isn't being outputted. Why is this? I've been trying to find a
> solution for about an hour and still no luck.

the boxes indicate either that the font used to display the text doesn't have
that char in it or slight encoding problem (question marks means the data's
completely garbaged by a fatal encoding error). you're using unicode (utf-8)
w/plain access odbc? that won't work, as the driver doesn't correctly handle
unicode data.

either:
- change to the "access for unicode" driver,
- change the application/data encoding to something it can handle (ie latin-1 if
you never use anything but western european languages),
- use another unicode capable db like sql server, mysql (i think >= 5),
postgres, etc.
- or strip out the chars that are getting messed up & replace them w/their
plain-jane equivalents.

X
xstortionistAuthor
Inspiring
August 28, 2008
I will changed the char-set, but any idea to why the information being outputted isn't displaying all the information that i submitted to the database?

that's my biggest question. I don't understand why all the text submitted to the database isn't being outputted correctly.

it cuts it off at a certain amount of characters.
K
Kronin555
Participating Frequently
August 27, 2008
It looks like your database columns are setup as 50-character varchars.

What database are you using? What data type are those 2 columns?
X
xstortionistAuthor
Inspiring
August 27, 2008
I'm using Microsoft Access 2000

The datatype is "Text"
Default View is "Datasheet"
sub data sheet Expanded "No"

not sure if this is any help. But I just took off character limit on the forms and still no luck.
N
Newsgroup_User
Inspiring
August 27, 2008
The first thing I would investigate is if this is an character encoding
issue.

What content where you trying to display?

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices