Yeah,
I agree... I'm pretty sure that "formatted" text is not really something that
can be considered a "character" of any type - double, single or otherwise.
However, accented or other special language characters would be able
to be entered into a modern database that supports unicode characters, which is
probably where the double-byte nchar would be useful to you (as far as Tango
reading unicode, that I am not sure about).
As for
writing it from Tango to the database - HTML forms encode all non alphanumeric
characters so you'd have to unencode any special chars that you entered in a
form before entering them into the db, or unencode them upon retrieval, so you
could just as well enter all your data as HTML...
The
other option you have assuming that you might wish to display the data on
something other than a web browser is to create your OWN system for "formatting"
characters... say "\i.Word" makes it Word, and "\b.Word" makes it
Word, and "\r.Word" makes it Word.
(This is kind of like troff for the UNIX geeks) With that
system, you will have a slightly more searchable table(without HTML entities,
or the potentially conflicting <>s), and will be able to format
the output easily with basic text processing functions.
JUST A
THOUGHT.
Happy
Coding!
Jim Kass
Web Developer
--
Forestweb: The Source for
Industry Intelligence
Best Content -- Most Relevant -- Best Delivery
http://www.forestweb.com
(310) 553 - 0008
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 06, 2003 8:24 AM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: Fomatting Fields within FormsYou cannot use bold or italics using any of the char fields as far as I know. However, if you fomat the returned text as encoding="none", you can add html to the database and have it returned correctly. Not exactly sure if this is what you are looking for. I use this when I need to add html tags to a database and when the data is returned, it will disply correctly.On # 2, we've had trouble using nchar and nvarchar data types and returning the data properly in WiTango (given that it's double-byte, although I don't think you need double-byte just for accented characters). We've had better success sticking with char and varchar fields. We've had no trouble with accented characters and those fields. However, I don't think you can format a text field with bold or italics as far as I know.
----- Original Message -----From: Cecilia CosTo: [EMAIL PROTECTED]Sent: Thursday, November 06, 2003 7:27 AMSubject: Witango-Talk: Fomatting Fields within Forms
Hello,
I am using Tango2000 for NT and SQL 2000
I would like to create a form with 2 fields, Style and Definition, that get stored in a SQL 2000 db. This will basically be a look up dictionary that users can add new styles and definitions as well as search for them.
I have 2 questions.
1. I need to be able to format some of the text (ie, bold, italicize) that is entered into the Definition field. I also need to be able to add accented characters such as Á and ç to this field.
Does anyone have any suggestions as to how I can do this?
2. I currently have the datatype in SQL 2000 set to nchar.........perhaps there is a better datatype?
Any assistance would be greatly appreciated.
Cecilia C. Cos
Data Analyst
Newsweek
251 W 57th Street, New York, NY 10019
212-445-4309
[EMAIL PROTECTED]________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf --________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf