View - Join based on dis-similar data types

I have a field defined as a character(50) data type, and the same field
stored in a transition table as a text type.

The view itself work based on the join, however sub-queries against the view
on that field do not return any data.

Example:

Table1
----
T1Data - Character(50)

Table2
----
T2Data - Text

View1:
---
SELECT T1Data from Table1 JOIN Table2 ON (Table1.T1Data = Table2.T2Data);

A select against View1
SELECT * FROM View1 returns all relevant records, however, adding a WHERE
clause produces no output.

Please advise.