FiveTech Software tech support forums

Wondering how do you know my mother tongue?

I've asked ChatGPT
The answer was:

... In Hyderabad, India, the main languages spoken are Telugu, Urdu and English. Telugu is the predominant language in Hyderabad and Telangana, while Urdu is used as the second official language...

Wow, I can't believe. We are downright ridiculous with our 4 multibytes.

Any utf8 encoded text of any language in the World can be displayed using any Windows font.
This reassures me 8)
Please try after this change.
అది పోయింది, ధన్యవాదాలు.

Transliterates to "Adi poyindi, dhanyavādālu" in english :wink:

https://i.postimg.cc/05LZQKp8/2023-11-26-09-36-32.png

We will look into the issue of tooltips. :D

Display of Utf8 depends purely on FWH
Does this mean that we can only use chars provided by FWH, even if we use a different font?

I tried it with the font 'unscii' from http://viznut.fi/unscii/ , unfortunately without success!

This has nothing to ...

thank you for the tip but I can't switch code pages for the following reason:

My application is a translation memory system (TMS) and should support as many languages as possible.
It should therefore be able to process, display and edit as many Unicode characters as possible at the same time , I ...

UTF8 encoding fails - switches to Ansi - in BUTTON/ TButton () and TBtnBmp () ToolTips!

Sample:
REQUEST HB_CODEPAGE_UTF8

FUNCTION Main()

LOCAL oDlg, oBtn

FW_SetUnicode( .T. )

DEFINE DIALOG oDlg TITLE "UTF8 encoding fails in Button ToolTips (is Ansi)!"

@ 2, 2 BTNBMP oBtn TOOLTIP "äöü ß ÄÖÜ ...

Ok, the movie takes place in 2001.

22 years later than Arthur C. Clarks predicted, it becomes reality for evveryone (HA user):
https://hackaday.com/2022/04/23/2022-sci-fi-contest-your-home-assistant-hal-9000/
https://www.home-assistant.io/integrations/openai_conversation/

The I can say 'Ok ...

ChatGPT cannot (yet) do this, HAL could have done it back in 1968

Enrico,

in German we have a saying: 'you are rowing back'
So we can assume that there ist non corresponding construct in plain SQL!

Enrico,

yes and
SELECT * FROM vll_term WHERE WORT LIKE CONCAT('%', _utf8'\u00DF', '%');
doesn't work. ChatGPT has obviously made a mistake here.

But when I want to use hex codes for the search string, MariaDB has HEX() and UNHEX().
What is the equivalent in plain SQL?

ChatGPT says: Certainly ...

Enrico,
THX for this helpful information, the rest I've done with ChatGPT :


For users who are in an UTF8 environment it's simple:

muchas gracias Antonio

For me, these two sources are helpful regarding UTF8:

1. 3.5 Codepage API - UTF8 and code page functions built into Harbour: http://www.kresin.ru/en/hrbfaq_3.html#Doc5

2. Unicode conversion functions for Harbour. http://www.hmgextended.com/files/CONTRIB/UnicodeConvert.prg unfortunately no longer ...

I tried the following in SQL SELECT * from vll_term WHERE WORT LIKE '%' + UNHEX('C39F') + '%'
The result is not as expected, maybe there is something wrong with the syntax?

The Google answer is:
https://i.postimg.cc/6Q3WfWWr/notfound.png

ChatGPT:
https://i.postimg.cc/KvJCrnRW/2023-11-17-08-26 ...

Very interesting and fascinating.
If you ask "... And fivewin" then the answer is very different: To convert an Excel worksheet containing addresses with columns for Street, City, State, and Zip to a SQL table using Harbour and FiveWin, you can follow these steps:

1. Load the Excel file: Use the ...