Bruce,
A quick check of California tags indicate that you can have a right or a left handprint. You might want to investigate to check if California can issue two different tags, one with the right handprint and one with the left handprint, or both handprint are considered one symbol. As far as storing the license plate and using it for searches, you will always have to check against the two columns since using only the first column can potentially result in up to 5 tags being found when you want only one. Also, do you need to make provisions to store the type of tag, such veteran, POW, etc.,? California seems to have a bunch of those. You can check if there is a font that has all the characters (CA DMV?) or even create your own font; however, you would have to distribute the font to anyone else that uses the application. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From: [email protected] [mailto:[email protected]] On Behalf Of Bruce Chitiea Sent: Monday, June 25, 2012 10:13 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Embedding Symbol Fonts within a Text String Thanks Larry. FWIW, My two-column workaround preserves the symbol's meaning from loss of the display font. The simple text-column 'mvplateno' stores an '@' character in place of the symbol: nnnn@nn n@nnnnn nnn@nnn ... followed by text-column 'mvplatesymbol' holding a symbol analog: <HND> for 'Hand' <HRT> for 'Heart' <STR> for 'Star' <PLS> for 'Plus' So the three strings above might be entered, stored and output as: COOL@LK <HND> I@RB95 <HRT> NON@SED <PLS> While this 'wastes' real estate for the majority of plates without symbols, the meaning is unambiguous to the viewer. It would just be really cool to embed the literal symbol in outputs (screen and printer) where display-space is gold. This would of necessity require symbol-font character storage within the database, so that symbols wouldn't get smoked by system wierdness. Cheers, Bruce -------- Original Message -------- Subject: [RBASE-L] - Re: Embedding Symbol Fonts within a Text String From: Lawrence Lustig <[email protected]> Date: Mon, June 25, 2012 7:22 am To: [email protected] (RBASE-L Mailing List) <<How does one switch fonts WITHIN a text string?>> You cannot switch fonts within a regular text string or control. If you cannot find a single font that has all the characters you need you will have to find another solution. You could do this using an RTF text string or memo control, but be aware that you will require much more space to store the text when RTF is involved (probably several hundred characters per license plate). If you can manage your output through HTML, you should be able to handle it that way also. -- Larry
