Visualice the ID field in Hexadecimal.

vikngo · Post by **vikngo** » Tue 24 Jan 2012 10:38

Hello, i see the field of ID with a text codification and only i can see a lot of symbols like this (�>J��³...) .
in the sight if below in the Data view appear the posibility of see the field with a hexadecimal code and i want to visualice it with hexadecimal code in the Data View.

Regards.
Thank you.

alexa · Post by **alexa** » Tue 24 Jan 2012 11:38

Hello,

Could you please provide us the following information:

- the full name of the product
- the product version
- the product edition (Express, Standard, or Professional)
- the version of the database you're working with

vikngo · Post by **vikngo** » Tue 24 Jan 2012 14:49

Hello alexa, i´m using the program dbforge Studio for MySQL.
The version 5.0.63 Express.

In other programs of database management i can see the fileds fine in hexadecimal. I got a big database and i need to access to this caracteristic easily. I would like to continous using dbforge.

Thank you.
Regards.

alexa · Post by **alexa** » Tue 24 Jan 2012 15:25

We are currently investigating the issue. In the meanwhile, could you please send us the result of the following queries:

SHOW VARIABLES LIKE 'version';
SHOW VARIABLES LIKE 'character_set_%';
SHOW CREATE TABLE your_table_name

vikngo · Post by **vikngo** » Tue 24 Jan 2012 15:54

Hello, Thank you.
This the result for that queries:

version: 5.0.90-community-nt
character_set_%: :

character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server utf8
character_set_system utf8
character_sets_dir C:\Program Files (x86)\MySQL\MySQL Server 5.0\share\charsets\

show create table: (The fields like GUID are what i would like to see in hexadecimal and are where i have the visualization problem).

Code: Select all

CREATE TABLE `address0` (
  `GGUID` binary(64) NOT NULL COMMENT 'Primary Key',
  `InsertTimestamp` datetime NOT NULL COMMENT 'Creation time of record',
  `InsertUser` varchar(40) NOT NULL COMMENT 'The person that created the record',
  `UpdateTimestamp` datetime NOT NULL COMMENT 'Update time of record',
  `UpdateUser` varchar(40) NOT NULL COMMENT 'The person that last updated the record',
  `IsDeleted` tinyint(1) NOT NULL default '0' COMMENT 'Indicates if a record is deleted',
  `IsTemplate` tinyint(1) NOT NULL default '0' COMMENT 'Indicates if a record is a template',
  `OwnerName` varchar(200) default NULL COMMENT 'The names of the permission owners',
  `OwnerGUID` binary(16) NOT NULL COMMENT 'The GGUID of the owner, i.e. the creator',
  `ForeignEditPermission` int(11) NOT NULL COMMENT 'The maximum permission a user can have when using foreign editpermissions',
  `AddressTerm` varchar(30) default NULL,
  `Title` varchar(30) default NULL,
  `ADDRESSLETTER` varchar(150) default NULL,
  `NAME` varchar(100) default NULL,
  `ChristianName` varchar(30) default NULL,
  `DEPARTMENT` varchar(255) default NULL,
  `InHouseZip` varchar(20) default NULL,
  `FUNCTION` varchar(100) default NULL,
  `Birthday` datetime default NULL,
  `COMPNAME` varchar(80) default NULL,
  `BankAccountNr` varchar(20) default NULL,
  `BankZipNr` varchar(20) default NULL,
  `FINANCIALINSTITUTE` varchar(100) default NULL,
  `Payment` varchar(30) default NULL,
  `FirstContact` varchar(30) default NULL,
  `FirstContactDate` datetime default NULL,
  `Rebate` decimal(19,4) default NULL,
  `TurnoverTaxId` varchar(30) default NULL,
  `STANDARDADDRESS` int(11) default NULL COMMENT '0 = Business, 1 = Besuch, 2 = privat',
  `STREET1` varchar(50) default NULL,
  `COUNTRY1` char(2) default NULL,
  `ZIP1` varchar(15) default NULL,
  `PoBoxZip1` varchar(15) default NULL,
  `PoBox1` varchar(15) default NULL,
  `POBOXTOWN1` varchar(50) default NULL COMMENT 'Town for POBOX1',
  `TOWN1` varchar(50) default NULL,
  `SUBURB1` varchar(50) default NULL,
  `AddressCheckedOn1` datetime default NULL,
  `AddressCheckedBy1` binary(16) default NULL,
  `MasterAddressId1` varchar(60) default NULL,
  `STREET2` varchar(50) default NULL,
  `COUNTRY2` char(2) default NULL,
  `ZIP2` varchar(15) default NULL,
  `PoBoxZip2` varchar(15) default NULL,
  `PoBox2` varchar(15) default NULL,
  `POBOXTOWN2` varchar(50) default NULL COMMENT 'Town for POBOX2',
  `TOWN2` varchar(50) default NULL,
  `SUBURB2` varchar(50) default NULL,
  `AddressCheckedOn2` datetime default NULL,
  `AddressCheckedBy2` binary(16) default NULL,
  `MasterAddressId2` varchar(60) default NULL,
  `STREET3` varchar(50) default NULL,
  `COUNTRY3` char(2) default NULL,
  `ZIP3` varchar(15) default NULL,
  `TOWN3` varchar(50) default NULL,
  `SUBURB3` varchar(50) default NULL,
  `AddressCheckedOn3` datetime default NULL,
  `AddressCheckedBy3` binary(16) default NULL,
  `MasterAddressId3` varchar(60) default NULL,
  `STREET4` varchar(50) default NULL,
  `COUNTRY4` char(2) default NULL,
  `ZIP4` varchar(15) default NULL,
  `DEACTIVATED` tinyint(1) NOT NULL default '0' COMMENT 'Indicates a deactivated address',
  `CATEGORY` varbinary(81) default NULL,
  `BRANCH` varbinary(17) default NULL,
  `CLASSIFICATION` varbinary(49) default NULL,
  `ACTIVITY_TYPE_ALLOWED` varbinary(65) default NULL,
  `ACTIVITY_TYPE_PREFERRED` varbinary(33) default NULL,
  `AGE` int(11) default NULL COMMENT 'EasyCare field',
  `NRTERMIN` int(11) default '0' COMMENT 'EasyCare field',
  `SARZT` varchar(20) default NULL COMMENT 'EasyCare field',
  `NATIONALITY` varchar(255) default NULL COMMENT 'EasyCare field',
  `CM_SPRACHE` varchar(255) default NULL COMMENT 'EasyCare field',
  `CM_FUNKTION` varchar(255) default NULL COMMENT 'EasyCare field',
  `RATSUCHENDER` tinyint(1) NOT NULL default '0' COMMENT 'EasyCare field',
  `AGENT` tinyint(1) NOT NULL default '0' COMMENT 'EasyCare field',
  `SCONTACT` datetime default NULL COMMENT 'EasyCare field',
  `LIST01` varbinary(33) default NULL,
  `LISTRESPONSABILITY` varbinary(33) default NULL,
  `LISTKONTAKTWEG` varbinary(33) default NULL,
  `LISTSNEEDED` varbinary(33) default NULL,
  `LISTACLASSIFICATION` varbinary(33) default NULL,
  `LISTSECURITY` varbinary(33) default NULL,
  `LISTANGEHOERINGEN` varbinary(33) default NULL,
  `LISTZUGEWIESEN` varbinary(33) default NULL,
  `LISTZUGANG` varbinary(33) default NULL,
  `LISTBRANCHE` varbinary(33) default NULL,
  `LISTMSTATUS` varbinary(33) default NULL,
  `CM_NOTES` varchar(1000) default NULL COMMENT 'CareCM field',
  `CM_NCONTACT` varchar(100) default NULL COMMENT 'EasyCare field',
  `ISKLIENT` tinyint(1) NOT NULL default '0' COMMENT 'CareCM field',
  `LISTPFLEGESTUFE` varbinary(33) default NULL,
  `LISTAKTIV` varbinary(33) default NULL,
  `LISTRELIGION` varbinary(33) default NULL,
  `HINWEIS` varchar(300) default NULL COMMENT 'CareCM field',
  `HILFELEISTUNG` varchar(300) default NULL COMMENT 'CareCM field',
  `X1` bigint(20) default NULL,
  `Y1` bigint(20) default NULL,
  `X2` bigint(20) default NULL,
  `Y2` bigint(20) default NULL,
  `X3` bigint(20) default NULL,
  `Y3` bigint(20) default NULL,
  `X4` bigint(20) default NULL,
  `Y4` bigint(20) default NULL,
  `PoBoxZip4` varchar(15) default NULL,
  `PoBox4` varchar(15) default NULL,
  `POBOXTOWN4` varchar(50) default NULL COMMENT 'Town for POBOX4',
  `TOWN4` varchar(50) default NULL,
  `SUBURB4` varchar(50) default NULL,
  `gwState4` varchar(30) default NULL,
  `gwAdditionalInfo4` varchar(100) default NULL,
  `AddressCheckedOn4` datetime default NULL,
  `AddressCheckedBy4` binary(16) default NULL,
  `MasterAddressId4` varchar(60) default NULL,
  `Notes2` varchar(255) default NULL,
  `NOTES2OverFlow` tinyint(1) NOT NULL default '0' COMMENT 'Indicates that the value of NOTES2 exceeds the maximum length, the full content is saved in TextFieldContents',
  `PhoneFieldStr2` varchar(30) default NULL,
  `PhoneFieldStr3` varchar(30) default NULL,
  `PhoneFieldStr4` varchar(30) default NULL,
  `PhoneFieldStr5` varchar(30) default NULL,
  `PhoneFieldStr7` varchar(30) default NULL,
  `PhoneFieldStr9` varchar(30) default NULL,
  `PhoneFieldStr10` varchar(30) default NULL,
  `FaxFieldStr1` varchar(30) default NULL,
  `FaxFieldStr4` varchar(30) default NULL,
  `FaxFieldStr5` varchar(30) default NULL,
  `MailFieldStr1` varchar(100) default NULL,
  `MailFieldStr2` varchar(100) default NULL,
  `MailFieldStr3` varchar(100) default NULL,
  `MailFieldStr5` varchar(100) default NULL,
  `WWWFieldStr0` varchar(100) default NULL,
  `WWWFieldStr1` varchar(100) default NULL,
  `WWWFieldStr5` varchar(100) default NULL,
  `gwState1` varchar(30) default NULL,
  `gwState2` varchar(30) default NULL,
  `gwState3` varchar(30) default NULL,
  `gwAdditionalInfo1` varchar(100) default NULL,
  `gwAdditionalInfo2` varchar(100) default NULL,
  `gwAdditionalInfo3` varchar(100) default NULL,
  `gwIBAN` varchar(42) default NULL,
  `gwBIC` varchar(11) default NULL,
  `BANKACCOUNTHOLDER` varchar(60) default NULL,
  `ImFieldStr1` varchar(100) default NULL,
  `ImFieldStr2` varchar(100) default NULL,
  `ImFieldStr3` varchar(100) default NULL,
  `ImFieldStr4` varchar(100) default NULL,
  `ImFieldStr5` varchar(100) default NULL,
  `ISORGANISATION` tinyint(1) NOT NULL default '0',
  `primaryOrganisation` binary(16) default NULL,
  `ImageGUID` binary(16) default NULL,
  `gwAddressFormat` varchar(3) default 'DE',
  `CheckedByUserOn` datetime default NULL,
  `imagePath` varchar(255) default NULL,
  `STANDARDEMAIL` int(11) default NULL,
  `PhoneID2` varchar(25) default NULL,
  `PhoneID3` varchar(25) default NULL,
  `PhoneID4` varchar(25) default NULL,
  `PhoneID5` varchar(25) default NULL,
  `PhoneID7` varchar(25) default NULL,
  `PhoneID9` varchar(25) default NULL,
  `PhoneID10` varchar(25) default NULL,
  `linkedUserId` int(10) default NULL,
  `linkedUserGuid` binary(16) default NULL,
  `CUSTOMERID` varchar(40) default NULL COMMENT 'Customer ID/number',
  PRIMARY KEY  (`GGUID`),
  KEY `IDX_Birthday8` (`Birthday`),
  KEY `IDX_CompName1` (`COMPNAME`),
  KEY `IDX_InsertTimestamp2` (`InsertTimestamp`),
  KEY `IDX_Name3` (`NAME`),
  KEY `IDX_Town15` (`TOWN1`),
  KEY `IDX_UpdateTimestamp6` (`UpdateTimestamp`),
  KEY `IDX_ADR_ChristianName` (`ChristianName`),
  KEY `IDX_Address0_Town2` (`TOWN2`),
  KEY `IDX_Address0_Town3` (`TOWN3`),
  KEY `IDX_Address0_Town4` (`TOWN4`),
  KEY `IDX_Address0_IsOrganisation` (`ISORGANISATION`),
  KEY `idx_ADDRESS_PhoneID2_CompName_Name_ChristianName` (`PhoneID2`,`COMPNAME`,`NAME`,`ChristianName`),
  KEY `idx_ADDRESS_PhoneID3_CompName_Name_ChristianName` (`PhoneID3`,`COMPNAME`,`NAME`,`ChristianName`),
  KEY `idx_ADDRESS_PhoneID4_CompName_Name_ChristianName` (`PhoneID4`,`COMPNAME`,`NAME`,`ChristianName`),
  KEY `idx_ADDRESS_PhoneID5_CompName_Name_ChristianName` (`PhoneID5`,`COMPNAME`,`NAME`,`ChristianName`),
  KEY `idx_ADDRESS_PhoneID7_CompName_Name_ChristianName` (`PhoneID7`,`COMPNAME`,`NAME`,`ChristianName`),
  KEY `idx_ADDRESS_PhoneID9_CompName_Name_ChristianName` (`PhoneID9`,`COMPNAME`,`NAME`,`ChristianName`),
  KEY `idx_ADDRESS_PhoneID10_CompName_Name_ChristianName` (`PhoneID10`,`COMPNAME`,`NAME`,`ChristianName`),
  KEY `IDX_ADDRESS_PRIMARYORGANISATION` (`primaryOrganisation`),
  KEY `IDX_ADDRESS0_Mail1` (`MailFieldStr1`),
  KEY `IDX_ADDRESS0_Mail2` (`MailFieldStr2`),
  KEY `IDX_ADDRESS0_Mail3` (`MailFieldStr3`),
  KEY `IDX_ADDRESS0_Mail5` (`MailFieldStr5`),
  KEY `IDX_ADDRESS0_CUSTOMERID` (`CUSTOMERID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Regards

alexa · Post by **alexa** » Thu 26 Jan 2012 13:09

Thank you for the reply.

We're currently examining this case and will get back to you with a result asap.

Currently, you can view hexadecimal values in Data Viewer where there is a possibility to switch between different views including hexadecimal.

To invoke the 'Data Viewer' tool window, select 'View -> Other Windows -> Data Viewer' from the main menu.